USE [master]
GO
DROP PROCEDURE AddLog;
DROP PROCEDURE AddProduct;
DROP PROCEDURE AddSystemPreference;
DROP PROCEDURE AddUser;
DROP PROCEDURE AddWork;
DROP PROCEDURE AddWorkHistory;
DROP PROCEDURE aspnet_AnyDataInTables;
DROP PROCEDURE aspnet_Applications_CreateApplication;
DROP PROCEDURE aspnet_CheckSchemaVersion;
DROP PROCEDURE aspnet_Membership_ChangePasswordQuestionAndAnswer;
DROP PROCEDURE aspnet_Membership_CreateUser;
DROP PROCEDURE aspnet_Membership_FindUsersByEmail;
DROP PROCEDURE aspnet_Membership_FindUsersByName;
DROP PROCEDURE aspnet_Membership_GetAllUsers;
DROP PROCEDURE aspnet_Membership_GetNumberOfUsersOnline;
DROP PROCEDURE aspnet_Membership_GetPassword;
DROP PROCEDURE aspnet_Membership_GetPasswordWithFormat;
DROP PROCEDURE aspnet_Membership_GetUserByEmail;
DROP PROCEDURE aspnet_Membership_GetUserByName;
DROP PROCEDURE aspnet_Membership_GetUserByUserId;
DROP PROCEDURE aspnet_Membership_ResetPassword;
DROP PROCEDURE aspnet_Membership_SetPassword;
DROP PROCEDURE aspnet_Membership_UnlockUser;
DROP PROCEDURE aspnet_Membership_UpdateUser;
DROP PROCEDURE aspnet_Membership_UpdateUserInfo;
DROP PROCEDURE aspnet_Paths_CreatePath;
DROP PROCEDURE aspnet_Personalization_GetApplicationId;
DROP PROCEDURE aspnet_PersonalizationAdministration_DeleteAllState;
DROP PROCEDURE aspnet_PersonalizationAdministration_FindState;
DROP PROCEDURE aspnet_PersonalizationAdministration_GetCountOfState;
DROP PROCEDURE aspnet_PersonalizationAdministration_ResetSharedState;
DROP PROCEDURE aspnet_PersonalizationAdministration_ResetUserState;
DROP PROCEDURE aspnet_PersonalizationAllUsers_GetPageSettings;
DROP PROCEDURE aspnet_PersonalizationAllUsers_ResetPageSettings;
DROP PROCEDURE aspnet_PersonalizationAllUsers_SetPageSettings;
DROP PROCEDURE aspnet_PersonalizationPerUser_GetPageSettings;
DROP PROCEDURE aspnet_PersonalizationPerUser_ResetPageSettings;
DROP PROCEDURE aspnet_PersonalizationPerUser_SetPageSettings;
DROP PROCEDURE aspnet_Profile_DeleteInactiveProfiles;
DROP PROCEDURE aspnet_Profile_DeleteProfiles;
DROP PROCEDURE aspnet_Profile_GetNumberOfInactiveProfiles;
DROP PROCEDURE aspnet_Profile_GetProfiles;
DROP PROCEDURE aspnet_Profile_GetProperties;
DROP PROCEDURE aspnet_Profile_SetProperties;
DROP PROCEDURE aspnet_RegisterSchemaVersion;
DROP PROCEDURE aspnet_Roles_CreateRole;
DROP PROCEDURE aspnet_Roles_DeleteRole;
DROP PROCEDURE aspnet_Roles_GetAllRoles;
DROP PROCEDURE aspnet_Roles_RoleExists;
DROP PROCEDURE aspnet_Setup_RemoveAllRoleMembers;
DROP PROCEDURE aspnet_Setup_RestorePermissions;
DROP PROCEDURE aspnet_UnRegisterSchemaVersion;
DROP PROCEDURE aspnet_Users_CreateUser;
DROP PROCEDURE aspnet_Users_DeleteUser;
DROP PROCEDURE aspnet_UsersInRoles_AddUsersToRoles;
DROP PROCEDURE aspnet_UsersInRoles_FindUsersInRole;
DROP PROCEDURE aspnet_UsersInRoles_GetRolesForUser;
DROP PROCEDURE aspnet_UsersInRoles_GetUsersInRoles;
DROP PROCEDURE aspnet_UsersInRoles_IsUserInRole;
DROP PROCEDURE aspnet_UsersInRoles_RemoveUsersFromRoles;
DROP PROCEDURE aspnet_WebEvent_LogEvent;
DROP PROCEDURE FindActiveUsers;
DROP PROCEDURE GetProducts;
DROP PROCEDURE GetRoles;
DROP PROCEDURE GetSystemPreference;
DROP PROCEDURE GetUserIDByUserName;
DROP PROCEDURE GetUserProfile;
DROP PROCEDURE IsNewInstall;
DROP PROCEDURE RemoveSystemPreference;
DROP PROCEDURE UpdateSystemPreference;
DROP TABLE aspnet_Users;
DROP TABLE aspnet_Applications;
DROP TABLE aspnet_Roles;
DROP TABLE aspnet_Membership;
DROP TABLE aspnet_Paths;
DROP TABLE aspnet_PersonalizationAllUsers;
DROP TABLE aspnet_PersonalizationPerUser;
DROP TABLE aspnet_Profile;
DROP TABLE aspnet_SchemaVersions;
DROP TABLE aspnet_UsersInRoles;
DROP TABLE aspnet_WebEvent_Events;
DROP TABLE [Log];
DROP TABLE Product;
DROP TABLE Sprint;
DROP TABLE SystemPreference;
DROP TABLE [User];
DROP TABLE Work;
DROP TABLE WorkHistory;